using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using datagridview1.DataSet1TableAdapters; namespace datagridview1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { CustomersTableAdapter adapter = new CustomersTableAdapter(); bindingSource1.DataSource = adapter.GetData(); dataGridView1.AutoGenerateColumns = false; int newColIndex = dataGridView1.Columns.Add("CompanyName", "CompanyName"); dataGridView1.Columns[newColIndex].DataPropertyName = "CompanyName"; newColIndex = dataGridView1.Columns.Add("ContactName", "ContactName"); dataGridView1.Columns[newColIndex].DataPropertyName = "ContactName"; newColIndex = dataGridView1.Columns.Add("Phone", "Phone"); dataGridView1.Columns[newColIndex].DataPropertyName = "Phone"; newColIndex = dataGridView1.Columns.Add("Contact", "Contact"); dataGridView1.CellFormatting += OnCellFormatting; dataGridView1.DataSource = bindingSource1; } private void OnCellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (e.ColumnIndex == dataGridView1.Columns["Contact"].Index) { e.FormattingApplied = true; DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; e.Value = string.Format("{0}:{1}", row.Cells["ContactName"].Value, row.Cells["Phone"].Value); } } } }